create external table if not exists jms_dim.dim_yl_nwm_business_indicators
(
    ID                 bigint,
    NETWORK_CODE       string,
    NETWORK_NAME       string,
    PROXY_CODE         string,
    PROXY_NAME         string,
    AREA_INFO_CODE     string,
    AREA_INFO_NAME     string,
    TOP_AREA_INFO_CODE string,
    TOP_AREA_INFO_NAME string,
    TARGET_COMPLETION  bigint,
    CREATE_BY          bigint,
    UPdate_BY          bigint,
    CREATE_BY_NAME     string,
    UPdate_BY_NAME     string,
    TARGET_MONTH       date,
    CREATE_TIME        date,
    UPdate_TIME        date,
    CREATE_CODE        string,
    UPdate_CODE        string
)comment '业务量指标配置'
stored as parquet
LOCATION '/dw/hive/jms_dim.db/external/dim_yl_nwm_business_indicators'
tblproperties (
'discover.partitions'='false',
'parquet.column.index.access'='true'
);